appid = ''
secretKey = ''

trans_col_list = ['C', 'E', 'F', 'I', 'K', 'L', 'N', 'Q']  # 需要合并的列

input_file1 = r'C:\Users\PC\Downloads\S01E19 Kernel Base 软件架构FMEA Software Architecture FMEA.xlsx'  # 待翻译文件
input_file2 = r'C:\Users\PC\Downloads\S01E19 Kernel Base 软件架构FMEA Software Architecture FMEA eng.xlsx'  # 待翻译文件
output_file = r'Merged.xlsx'  # 翻译后输出的文件
target_sheet_key_word1 = r'FMEA'  # 工作簿中工作表的名称
target_sheet_key_word2 = r'FMEA'  # 工作簿中工作表的名称

# 不需要翻译的格子
skip_list = [
    '',
    '\\',
    '/',
    'NA',
    'NO',
    'YES',
    'None',
]


def check_value(value):
    assert value != '' and value is not None, 'Some configuration items are not configured, please check!'


def check_dict_value(my_dict: dict):
    list(map(check_value, my_dict.values()))


list(map(check_value, [appid, secretKey]))
